Automatically inserts argument placeholders between parentheses when you choose an @function name from this menu. Not available if the console is closed.
Automatically inserts argument placeholders between parentheses when you choose an @function name from this menu.
Lets you insert an @function into a formula without using placeholder arguments. Not available if the console is closed.
Lets you insert an @function into a formula without using placeholder arguments.
Lists @functions alphabetically by name, ready for you to paste into a formula.
Averages the values in a list. @AVG is a statistical @function.
Adds the values in a list. @SUM is a statistical @function.
Automatically sums values above or to the left of the selected cell or range, or throughout a range if cells in the bottom or or right column are blank. Not available if a drawn object is selected.
Automatically sums values above or to the left of the selected cell or range, or throughout a range if cells in the bottom or right column are blank.
Cycles the selected address in a formula through eight combinations of relative or absolute sheet, row, and column. Also changes from an absolute to a relative range name. Available only if you're creating or editing a cell entry.
Cycles the selected address in a formula through eight combinations of relative or absolute sheet, row, and column. Also changes from an absolute to a relative range name.
Calculates all formulas in the worksheet, or converts the formula you're editing to its value.
Lets you calculate formulas, change the type of references used in formulas, use SmartSum to create instant totals, and paste any of 104 @functions, with or without arguments, into a formula.
